UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qzePm77ru8blw35rTArjI+wCR3+a8+RUGgUBb/+UrtQ=' 
WHERE 
  key_id = 'fd62f53977f93c19cda5f01a9a577dd1c97e8ac5ab2d6cb8daf88317679aea42' 
  AND (
    token = 'qzePm77ru8blw35rTArjI+wCR3+a8+RUGgUBb/+UrtQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034