UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gGvi/W4KBbzBaVcuxCdp/9W193n+A4YW9GjZl0HfK4Q='
WHERE
key_id = 'fd7226444bd036c96aa0483aaa34c46852e83b6733f2926347d303a745713202'
AND (
token = 'gGvi/W4KBbzBaVcuxCdp/9W193n+A4YW9GjZl0HfK4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)