UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HpREr+eoGoqu+lyQ9sv/9BuqxjoNPxrihp6y4lNR18='
WHERE
key_id = 'f4ed0abba9344d6116792c117c36747c3a752b7c5eb3b017dddc4a816fb77eda'
AND (
token = '6HpREr+eoGoqu+lyQ9sv/9BuqxjoNPxrihp6y4lNR18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)