UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y/bDGs4i5jfrO5RJv6IxxO5iBf7th1s5IhKi7gdXkYo='
WHERE
key_id = '04ae9a401b43ea266fdae23635cb6f7ba6923d79886489898f9e777d43ad03ed'
AND (
token = 'Y/bDGs4i5jfrO5RJv6IxxO5iBf7th1s5IhKi7gdXkYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)