UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gG5n2onKkuLVxHNiGx3lpA1+84ZgC5fJd8q2X+x9EUE='
WHERE
key_id = '8041b6f860d4b5bdb61877bd7d100f4018224c3e9aaa024a4ad69b21574e7ed9'
AND (
token = 'gG5n2onKkuLVxHNiGx3lpA1+84ZgC5fJd8q2X+x9EUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)