UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HZqvCZPb/ZOsN4YVp4hbEQPLPXQoiMB5NZJKO0nG+Y='
WHERE
key_id = '76bc6079b14426f64c797719f21b4b368ec8489fa3575cf24c78973c08cd6342'
AND (
token = '4HZqvCZPb/ZOsN4YVp4hbEQPLPXQoiMB5NZJKO0nG+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)