UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2mbcaBS8DTKWtsu6VgTb+QSax+T8StSAHWNCVAiO7yM=' 
WHERE 
  key_id = '8e48518969537e63f4a6b89b33449bc5c8feb6fb5ba9f100b6ac15d9cf04f039' 
  AND (
    token = '2mbcaBS8DTKWtsu6VgTb+QSax+T8StSAHWNCVAiO7yM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031