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