UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V0q9zwlb7EinmpBHytuGMgyjsbIOmGesPK/j8tgHbcU='
WHERE
key_id = '09ff80cd95778a0a0ae0359d77023428679d6bc96a384520de1167b1d1f5ebc3'
AND (
token = 'V0q9zwlb7EinmpBHytuGMgyjsbIOmGesPK/j8tgHbcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)