UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8LpgxgPsXPd1ihlVRhqapHWg0Bv+DWoCgZ3OKnHh650='
WHERE
key_id = '29bba45bc3d75c50047bd44a06d431ed29ac09a86f3ef45100f5efc7b3db6ded'
AND (
token = '8LpgxgPsXPd1ihlVRhqapHWg0Bv+DWoCgZ3OKnHh650='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)