UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPxn+7eWO8doOHzvEuFsDLHEq4DYNyNux9iyWu0sF2E='
WHERE
key_id = 'e9c3275a1118a4c163719c79eae4df728843492f1ce7fbbd350e7322696a1385'
AND (
token = 'gPxn+7eWO8doOHzvEuFsDLHEq4DYNyNux9iyWu0sF2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)