UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6XBoaJ/wtnSrl+wC1R4ngndCCLFQ6FwrJ1raRxVpKNQ=' 
WHERE 
  key_id = 'cde7803f6681be4b3100d82a2bd1d222081d0e34f4f75bae57902714a3b50fd9' 
  AND (
    token = '6XBoaJ/wtnSrl+wC1R4ngndCCLFQ6FwrJ1raRxVpKNQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019