UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Sf0QY5JPXtfjjZUKhWnxI9crnfk02PcGIJxbX/4FOI='
WHERE
key_id = '6f06fe1621db226777e2d54de2c650be41763c3ea27e516144319871d4b6ec31'
AND (
token = '8Sf0QY5JPXtfjjZUKhWnxI9crnfk02PcGIJxbX/4FOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)