UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TU3sDr4fJl+Q6aIa8xLFle8ps9lnA1w4Zi5+GgrYjk4=' 
WHERE 
  key_id = 'cccb615a73ef62e90534456850263736eae0c8a054701a34eaaee82c5afcc5c6' 
  AND (
    token = 'TU3sDr4fJl+Q6aIa8xLFle8ps9lnA1w4Zi5+GgrYjk4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053