UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H/s6DEXU84YVMwRKGtYoQVbxZWtn8a/UwbILwIezvTo='
WHERE
key_id = '254d88922d8278d65fbcfb8dd0b8d2ea835105f37d1118837ba29ca17f13458d'
AND (
token = 'H/s6DEXU84YVMwRKGtYoQVbxZWtn8a/UwbILwIezvTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)