UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bEdYc3naLR/9LFfd7FYJfid18e58FDTyVzTneZFboVU='
WHERE
key_id = '89be163c84a59d73aa143cf71b2b6fd47f3489c84ad0a372238186f18d10abbc'
AND (
token = 'bEdYc3naLR/9LFfd7FYJfid18e58FDTyVzTneZFboVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)