UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'coJBdsY8XC4QDd4m8Ti7J9iQCG9TrhlkMiICNM8N/Gs='
WHERE
key_id = 'e8f27c8e24c85586687fe4794cf5097ae64d787e06c636e8782751993380b430'
AND (
token = 'coJBdsY8XC4QDd4m8Ti7J9iQCG9TrhlkMiICNM8N/Gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)