UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXzlmzZcKVJOUEA3z08Y4auz9JVCrs7bzOzhpSswfv8='
WHERE
key_id = '7c5402d534bf85e23ce6795bc858bab9a36ece32b07ee29a1c4a6177cb3298ca'
AND (
token = 'XXzlmzZcKVJOUEA3z08Y4auz9JVCrs7bzOzhpSswfv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)