UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXUuU4iJOIA6Uq3KykDE5zX2ihh43VGeXCDZn0T4BVw='
WHERE
key_id = '538fc2780ce4e494543ccb406f79b509f0c1aad10786794240d2d2e02c572a6e'
AND (
token = 'TXUuU4iJOIA6Uq3KykDE5zX2ihh43VGeXCDZn0T4BVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)