UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1MWly6BFMPMS7SvFEjxS9r8pED42Fr/t6ZIC65R/jgE='
WHERE
key_id = '67bf3f5147d34ddaf213306eb49b42c87e400d18e0a08b4d9f7e541e3038aeae'
AND (
token = '1MWly6BFMPMS7SvFEjxS9r8pED42Fr/t6ZIC65R/jgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)