UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VcSkbQqHoNBNDVq7bXNcemPvh1YDLW61yusNObHBPqY='
WHERE
key_id = '0d68f0461a640885a31c661088068094828b89907e30b6679427cc88a8b64b40'
AND (
token = 'VcSkbQqHoNBNDVq7bXNcemPvh1YDLW61yusNObHBPqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)