UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QmITYCbZZAc+oZujrK4Z9LnNDhxSsibvJEyD4oEGRo='
WHERE
key_id = '8754b667cc7e250ce2e8a544b2712aece30ae14d755e296741c847174778a453'
AND (
token = '6QmITYCbZZAc+oZujrK4Z9LnNDhxSsibvJEyD4oEGRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)