UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RFNGlmql5jYHgrNy4kV63ZHfdtLEoQDM8nvYv+waMTw='
WHERE
key_id = '627a916e5f10bab673131c755cd99e084a038ef978c95e0a23a28843e29717ef'
AND (
token = 'RFNGlmql5jYHgrNy4kV63ZHfdtLEoQDM8nvYv+waMTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)