UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'r+tib83y5RDER+0EG+rg+/4kI/T/0BMePmjg+xRhfMo=' 
WHERE 
  key_id = '5c72856aa175d76a5cf05fdad878a4e00b64ffaabb35a468177fe33f01b83b28' 
  AND (
    token = 'r+tib83y5RDER+0EG+rg+/4kI/T/0BMePmjg+xRhfMo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035