UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JipFE9pGl2exGQjegZOyG8lOjpcewnW67B6Bope61ps='
WHERE
key_id = '1f5cdf5bfb2a8abfa415b3ec45c7df018e50e76a28f64ae9a1b0894680ad417f'
AND (
token = 'JipFE9pGl2exGQjegZOyG8lOjpcewnW67B6Bope61ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)