UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHqde3LDpE5bvjjxNmsAYbx3kr0EmdjG5lyMTlNPamA='
WHERE
key_id = '194009ee733219b63960bccbaf4855d609f4d7e657e3a8f4867bc94e8631ef0e'
AND (
token = 'tHqde3LDpE5bvjjxNmsAYbx3kr0EmdjG5lyMTlNPamA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)