UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HSoWW1GH17bPhxpVmzHuYoYtotnoJBXShZTBYuy5Hds='
WHERE
key_id = 'af5e995263005208b330e49ba546d4b4c5b1e6df9a48ca02f1e7fc97fbdf0982'
AND (
token = 'HSoWW1GH17bPhxpVmzHuYoYtotnoJBXShZTBYuy5Hds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)