UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UBPdJrBPCP5tw3ZcPzF3+XqNYwBqbzN6L9d1RuX9rrc='
WHERE
key_id = '7e0517a8061475d1bb3f371b095b155a2e22cb78a7f4a4db00f4657f655eeb71'
AND (
token = 'UBPdJrBPCP5tw3ZcPzF3+XqNYwBqbzN6L9d1RuX9rrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)