UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1q5wbU0Dq0yaFB8fq+VzKPY3YYWhcYViQ2vTk8zEsHo='
WHERE
key_id = 'e737f84764b43e2406f0a15ae44dacb0f4cfdcc2479bf16d8608d4cf965cf930'
AND (
token = '1q5wbU0Dq0yaFB8fq+VzKPY3YYWhcYViQ2vTk8zEsHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)