UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCBx+eljVYG2T1VylLqi5wkreRKr0Rkp8GVoy1FT+lU='
WHERE
key_id = '1a8189af83b40545407a4357e4bb00ce328316e10af0d6d87acfb711a86ea851'
AND (
token = 'QCBx+eljVYG2T1VylLqi5wkreRKr0Rkp8GVoy1FT+lU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)