UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfUyqmAiLxLAdzWI3wCQv8Oe6R4LLbh6Wn01q6yFF6c='
WHERE
key_id = 'f62390d87f6722e012215977bccb88493ba37759f6b6892ef3e4996423379692'
AND (
token = 'ZfUyqmAiLxLAdzWI3wCQv8Oe6R4LLbh6Wn01q6yFF6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)