UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9rL+923vacASLWvm3PJldYLOyhe3tOz2y02GL7PnGM='
WHERE
key_id = '7646af7477811be0808f560881c2e7ef77dfced11ee873b9ec455f6f54b2ab49'
AND (
token = 'N9rL+923vacASLWvm3PJldYLOyhe3tOz2y02GL7PnGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)