UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sx0zqH7izRKtjBYVuS82ChlYX9KCPpJK1B3f6/tw7J4='
WHERE
key_id = '968760f3b1522c6edc25cc34c740af2fe76f3aca360c1c768e152ecb4121f315'
AND (
token = 'sx0zqH7izRKtjBYVuS82ChlYX9KCPpJK1B3f6/tw7J4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)