UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hbMEbkIZiRyFxVJJonqZ3tFbBpYrQvu8jGUXjhztzAo='
WHERE
key_id = '64c3c35637c7ab697e9c9a9ca869a9e712e9a483a916c9034ef609d1508b1fb6'
AND (
token = 'hbMEbkIZiRyFxVJJonqZ3tFbBpYrQvu8jGUXjhztzAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)