UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hgWaYhCv0xoQbpZqzJHcxFsXYaRTtss4y2m2Hnxel0='
WHERE
key_id = 'ade8f5310fa3a72500f7f0d5c88794aa8b1a905a5a40a7ca817badd0c66346f1'
AND (
token = '9hgWaYhCv0xoQbpZqzJHcxFsXYaRTtss4y2m2Hnxel0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)