UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ub5Z7Y8HxqShpteR21GHjVEmyFlmJMB92qgBHNpLioA=' 
WHERE 
  key_id = '5cdda6936f5ea2c7f2a2a9876e1207911323e8a3d6238f97762816bbedb1962c' 
  AND (
    token = 'ub5Z7Y8HxqShpteR21GHjVEmyFlmJMB92qgBHNpLioA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029