UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VjCBYABTVDIePVyFCr1ss5fWHyBYR6BryL0yAoS6qm0='
WHERE
key_id = '4ada342926d17fa04afd3051956444f1783d71bd79483cd97a98b2a0b3bc1ea7'
AND (
token = 'VjCBYABTVDIePVyFCr1ss5fWHyBYR6BryL0yAoS6qm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)