UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foqmrPWkbvLTtY3QgFLTex1a+vg3Y4gG8dA5eK4wgiQ='
WHERE
key_id = 'a3b5adb200b486508ab3c5d60f8372913190be2d85b5bbef7ee4b1b60e6ff662'
AND (
token = 'foqmrPWkbvLTtY3QgFLTex1a+vg3Y4gG8dA5eK4wgiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)