UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZXS2CYW2ZgCIBVq4TQvDQYzY+IHtQZECf2SGs+RnHw='
WHERE
key_id = '1bb7f8b24dccf797b8d03f6f017ccfefc6fd093576c2c9274243291da1234250'
AND (
token = 'JZXS2CYW2ZgCIBVq4TQvDQYzY+IHtQZECf2SGs+RnHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)