UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lAYZij8vXcvJzcejVaMNc2B/7bJD4EqkIAV5xzGfAv8='
WHERE
key_id = 'e918b9a80d635353bbdd9677bd85b0ffad5221515928f4f7a105009608dd54ff'
AND (
token = 'lAYZij8vXcvJzcejVaMNc2B/7bJD4EqkIAV5xzGfAv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)