UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/mz9n2c+WgXfizt90HFlsh7pMxTgDa62OBhp19dFKA='
WHERE
key_id = '558d3e5b001c185172824c9e4022c611abf3876802e65012b5315e6c1e1262f0'
AND (
token = 'a/mz9n2c+WgXfizt90HFlsh7pMxTgDa62OBhp19dFKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)