UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6B7eEJ/uNx2CT62gA0pf0TAguhQpjVOWm+92gzVnhDU='
WHERE
key_id = 'c339827079e0ed40a87d0dae97105a8f64fc687cc58020bdc4c9fbee2c839453'
AND (
token = '6B7eEJ/uNx2CT62gA0pf0TAguhQpjVOWm+92gzVnhDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)