UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6wWI19HaKESoQGBOQ/DYdvSvcadjP83CaMHE9r4dIxA='
WHERE
key_id = 'd9754143682a42ff514a242f679e839fc83120a4cd99ebaba4a84324bb95322d'
AND (
token = '6wWI19HaKESoQGBOQ/DYdvSvcadjP83CaMHE9r4dIxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)