UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k/142R1OidM1zdTAe1nber6MxLC/Ky2OuBcL2W2O6qA='
WHERE
key_id = '2a40a60bf6842dd65413f70ce05d10e3b84402a988bc7238673f4195ceaee999'
AND (
token = 'k/142R1OidM1zdTAe1nber6MxLC/Ky2OuBcL2W2O6qA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)